lateral join
Short Description
The lateral join node indicates a correlated subquery with the of a FOR LOOP
Detailed Description​
lateral joins are correlated subqueries that reference another query or subquery within its SELECT statement. Unlike normal correlated subqueries, LATERAL subqueries iterate through each row in the referenced query for each row in the inner. This behaviour is like a FOR LOOP.
Additional Links​
- CockroachDB Docs - Lateral Joins
- CockroachDB Docs - Lateral Subqueries
- CockroachDB Docs - Supported Join Algorithms
- CockroachDB Docs - Cost Based Optimizer
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.